package com.ddtc.repo;

import com.ddtc.object.SourceInfo;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;

import java.util.List;

public interface SourceInfoRepository extends CrudRepository<SourceInfo,Integer> {


    @Query(nativeQuery = true,value = "select w.requestSource from t_request_source_info" +
            " w where w.BoundAppId = :appId and w.requestSource LIKE '%wxapp%' " )
    String findRequestSourceByAppId(@Param("appId") String appId);
}
